Once you have created a materials batch in Micronet, you can import materials data which has been exported from another system in CSV (comma separated values) format.
The file must be formatted as follows, with a carriage return at the end of each line:
Job type (73),"job number",cost centre (0-9),"batch number","blank","stage","description (item description)","item number",actual quantity,billable quantity,actual cost,0,line total (inc tax),job transaction order total (ex tax),sell price or unit charge,'discount type (P)',tax percentage,"warehouse number",'tax type (S)',"transaction date"
For example:
73,"A100021",0,"BATCH1","","1","My item Desc","111112",3,3,20,0,99,0,30,'P',10,"1",'S',"17/07/2016"
|
Reference If you want to enter materials data directly into Micronet, refer to "Maintaining Materials Details". |
To import materials data from a CSV file into MJC:
Micronet displays the Job Material Batch Control screen.
Micronet displays the Import CSV Materials screen.
Micronet imports the CSV file into a standard MJC batch for editing, printing or processing. When the data has been imported, Micronet produces an audit report showing all costs and materials along with a job summary of the costs allocated.
For information on how to open and review a materials batch, refer to "Recalling a Materials Batch".
Refer to "Managing Completed Materials Batches".